home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Windows 95 API Bible
/
Windows 95 API Bible 3 Disc Set.iso
/
Win32 API Bible Book 3 of 3.iso
/
chapter7
/
bindcol.c
next >
Wrap
C/C++ Source or Header
|
1996-04-28
|
10KB
|
284 lines
#include <windows.h>
#include <stdio.h>
#include "bindcol.h"
#include "sqlext.h"
#if defined (WIN32)
#define IS_WIN32 TRUE
#else
#define IS_WIN32 FALSE
#endif
#define IS_NT IS_WIN32 && (BOOL)(GetVersion() < 0x80000000)
#define IS_WIN32S IS_WIN32 && (BOOL)(!(IS_NT) && (LOBYTE(LOWORD(GetVersion()))<4))
#define IS_WIN95 (BOOL)(!(IS_NT) && !(IS_WIN32S)) && IS_WIN32
HINSTANCE hInst; // current instance
LPCTSTR lpszAppName = "MyApp";
LPCTSTR lpszTitle = "SQLBindCol()";
BOOL RegisterWin95( CONST WNDCLASS* lpwc );
int APIENTRY WinMain( HINSTANCE hInstance, HINSTANCE hPrevInstance,
LPTSTR lpCmdLine, int nCmdShow)
{
MSG msg;
HWND hWnd;
WNDCLASS wc;
wc.style = CS_HREDRAW | CS_VREDRAW;
wc.lpfnWndProc = (WNDPROC)WndProc;
wc.cbClsExtra = 0;
wc.cbWndExtra = 0;
wc.hInstance = hInstance;
wc.hIcon = LoadIcon (hInstance, lpszAppName);
wc.hCursor = LoadCursor(NULL, IDC_ARROW);
wc.hbrBackground = (HBRUSH)(COLOR_WINDOW+1);
wc.lpszMenuName = lpszAppName;
wc.lpszClassName = lpszAppName;
if ( IS_WIN95 )
{
if ( !RegisterWin95( &wc ) )
return( FALSE );
}
else if ( !RegisterClass( &wc ) )
return( FALSE );
hInst = hInstance;
hWnd = CreateWindow( lpszAppName,
lpszTitle,
WS_OVERLAPPEDWINDOW,
CW_USEDEFAULT, 0,
CW_USEDEFAULT, 0,
NULL,
NULL,
hInstance,
NULL
);
if ( !hWnd )
return( FALSE );
ShowWindow( hWnd, nCmdShow );
UpdateWindow( hWnd );
while( GetMessage( &msg, NULL, 0, 0) )
{
TranslateMessage( &msg );
DispatchMessage( &msg );
}
return( msg.wParam );
}
BOOL RegisterWin95( CONST WNDCLASS* lpwc )
{
WNDCLASSEX wcex;
wcex.style = lpwc->style;
wcex.lpfnWndProc = lpwc->lpfnWndProc;
wcex.cbClsExtra = lpwc->cbClsExtra;
wcex.cbWndExtra = lpwc->cbWndExtra;
wcex.hInstance = lpwc->hInstance;
wcex.hIcon = lpwc->hIcon;
wcex.hCursor = lpwc->hCursor;
wcex.hbrBackground = lpwc->hbrBackground;
wcex.lpszMenuName = lpwc->lpszMenuName;
wcex.lpszClassName = lpwc->lpszClassName;
// Added elements for Windows 95.
//...............................
wcex.cbSize = sizeof(WNDCLASSEX);
wcex.hIconSm = LoadImage(wcex.hInstance, lpwc->lpszClassName,
IMAGE_ICON, 16, 16,
LR_DEFAULTCOLOR );
return RegisterClassEx( &wcex );
}
LRESULT CALLBACK WndProc( HWND hWnd, UINT uMsg, WPARAM wParam, LPARAM lParam )
{
static HENV hEnv = NULL;
static HDBC hDBC = NULL;
static HWND hList = NULL;
UCHAR szSqlStr[] = "Select dept_id, dept_name, dept_head_id From department";
switch( uMsg )
{
case WM_CREATE :
{
RETCODE retCode;
// Allocate Environment and Connection.
//.....................................
SQLAllocEnv( &hEnv );
SQLAllocConnect( hEnv, &hDBC );
// Connect to the data source
//...........................
retCode = SQLConnect( hDBC,
"Test Data Source", SQL_NTS,
"DBA", SQL_NTS,
"SQL", SQL_NTS );
if ( retCode != SQL_SUCCESS )
{
SQLFreeConnect( hDBC );
SQLFreeEnv( hEnv );
return( -1 );
}
if ( retCode == SQL_SUCCESS )
{
int nTabSize = 60;
hList = CreateWindow( "LISTBOX", "",
LBS_NOTIFY | LBS_USETABSTOPS |
LBS_NOINTEGRALHEIGHT |
WS_BORDER | WS_CHILD |
WS_VISIBLE | WS_VSCROLL,
0, 0, 0, 0,
hWnd, (HMENU)101,
hInst, NULL );
SendMessage( hList, LB_SETTABSTOPS,
1, (LPARAM)&nTabSize );
}
}
break;
case WM_SIZE :
MoveWindow( hList, 0, 0, LOWORD( lParam ),
HIWORD( lParam ), TRUE );
break;
case WM_COMMAND :
switch( LOWORD( wParam ) )
{
case IDM_TEST :
{
HSTMT hStmt;
UCHAR szDeptId [32];
UCHAR szDeptName [32];
UCHAR szDeptHeadId[32];
UCHAR szLBStr [128];
SDWORD dwTypeLen;
RETCODE retCode;
int i = 0;
// Allocate a statement handle for the query.
// ..........................................
SQLAllocStmt( hDBC, &hStmt );
// Call SQLExecDirect() to
// compile and execute the query.
// ..............................
retCode = SQLExecDirect( hStmt,szSqlStr,sizeof(szSqlStr));
if( retCode == SQL_SUCCESS ||
retCode == SQL_SUCCESS_WITH_INFO )
{
// Bind a column to the dept_id, dept_name, and
// dept_head_id columns in the result set.
// ............................................
SQLBindCol( hStmt, 1, SQL_C_CHAR,
szDeptId, sizeof( szDeptId ),
&dwTypeLen );
SQLBindCol( hStmt, 2, SQL_C_CHAR,
szDeptName, sizeof( szDeptName ),
&dwTypeLen );
SQLBindCol( hStmt, 3, SQL_C_CHAR,
szDeptHeadId, sizeof( szDeptHeadId ),
&dwTypeLen );
// Fetch all the records and
// put them in the list box.
//..........................
retCode = SQLFetch( hStmt );
while ( retCode == SQL_SUCCESS &&
i < 5 )
{
szLBStr[0] = '\0';
strcat( szLBStr, szDeptId );
strcat( szLBStr, "\t" );
strcat( szLBStr, szDeptName );
strcat( szLBStr, "\t" );
strcat( szLBStr, szDeptHeadId );
SendMessage( hList, LB_ADDSTRING,
0, (LPARAM)szLBStr );
retCode = SQLFetch( hStmt );
}
}
// Free the statement handle.
// ..........................
SQLFreeStmt( hStmt, SQL_DROP );
}
break;
case IDM_ABOUT :
DialogBox( hInst, "AboutBox", hWnd, (DLGPROC)About );
break;
case IDM_EXIT :
DestroyWindow( hWnd );
break;
}
break;
case WM_DESTROY :
PostQuitMessage(0);
// Disconnect Environment.
//........................
SQLDisconnect( hDBC );
// Free Connection and Environment.
//.................................
SQLFreeConnect( hDBC );
SQLFreeEnv( hEnv );
break;
default :
return( DefWindowProc( hWnd, uMsg, wParam, lParam ) );
}
return( 0L );
}
LRESULT CALLBACK About( HWND hDlg,
UINT message,
WPARAM wParam,
LPARAM lParam)
{
switch (message)
{
case WM_INITDIALOG:
return (TRUE);
case WM_COMMAND:
if ( LOWORD(wParam) == IDOK
|| LOWORD(wParam) == IDCANCEL)
{
EndDialog(hDlg, TRUE);
return (TRUE);
}
break;
}
return (FALSE);
}